The object of this lab is to gain some familiarity with the types of modelling tools that are available for most popular RDBMS. Use the MySQL Workbench Data Modelling Tool to create a new schema for the Pizza Orders Example. 1. In Data Modeler Create two tables that we saw in the "Pizza Orders" Normalisation Exercise. For Simplicity here we will only describe creating the "Order" and "Customer" tables (you don't have to include all of the attributes initially): - Order: - Order No - Order Date - Customer: - Customer ID - Customer Name - Customer Address - PostCode 2. When you have created a Logical Model for the two tables in the data modeller, now create a 1-to-Many relationship, Each Customer can "place" many orders, Each order is "placed by" a single customer 3. In MySQL Workbench generate and save the SQL for the new schema. Database -> Forward Engineer. 4. Take a look at the resulting SQL and verify that it is correct. 5. Save the SQL schema to a file. 6. Use command line SQL queries to insert some data into the new schema.